package com.cnhis.cloudhealth.clinical.hosnurse.hossendadvice.dao;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.cnhis.cloudhealth.commons.dao.BaseDao;
import com.cnhis.cloudhealth.commons.utils.Page;
@SuppressWarnings("rawtypes")
@Repository
public class HosSendAdviceDao extends BaseDao{
	public Integer advicesendint(Map map)throws Exception{
		String getCountSqlDef = "HosSendAdvice.advice_send_drugCount1";
		/*获取查询结果的记录总数*/
		int total = ((Integer)getSqlSession().selectOne(getCountSqlDef,map)).intValue();
		return total;
	}
	public Page advicesendList(Map map, int currPage,int pageSize)throws Exception{
		String getCountSqlDef = "HosSendAdvice.advice_send_drugCount";
		
		/*获取查询结果的记录总数*/
		int total = ((Integer)getSqlSession().selectOne(getCountSqlDef,map)).intValue();
		int  pageIndex = currPage-1;
		pageIndex = pageIndex<0?0:pageIndex;
		currPage = currPage<1?1:currPage;
		/*开始记录的位置*/
		int  startNum = 0;
		startNum = pageIndex*(pageSize<1?1:pageSize);
		map.put("currPage", startNum);
		map.put("pageSize", pageSize);
		List  list =  queryForList("HosSendAdvice.advice_send_drug", map);
		return new Page(list, pageSize,total,currPage);
		
	}
	public Page advicesendallList(Map map, int currPage,int pageSize)throws Exception{
		List  list =  queryForList("HosSendAdvice.advice_send_drugall", map);
		return new Page(list, pageSize,1,currPage);
		
	}
	public Integer otheradvicesendint(Map map)throws Exception{
		String getCountSqlDef = "HosSendAdvice.other_advice_send_drugCount1";
		/*获取查询结果的记录总数*/
		int total = ((Integer)getSqlSession().selectOne(getCountSqlDef,map)).intValue();
		return total;
	}
	public Page otheradvicesendList(Map map, int currPage,int pageSize)throws Exception{
		String getCountSqlDef = "HosSendAdvice.other_advice_send_drugCount";
		
		/*获取查询结果的记录总数*/
		int total = ((Integer)getSqlSession().selectOne(getCountSqlDef,map)).intValue();
		int  pageIndex = currPage-1;
		pageIndex = pageIndex<0?0:pageIndex;
		currPage = currPage<1?1:currPage;
		/*开始记录的位置*/
		int  startNum = 0;
		startNum = pageIndex*(pageSize<1?1:pageSize);
		map.put("currPage", startNum);
		map.put("pageSize", pageSize);
		List  list =  queryForList("HosSendAdvice.other_advice_send_drug", map);
		return new Page(list, pageSize,total,currPage);
		
	}
	public Page otheradvicesendallList(Map map, int currPage,int pageSize)throws Exception{
		List  list =  queryForList("HosSendAdvice.other_advice_send_drugall", map);
		return new Page(list, pageSize,1,currPage);
		
	}
	 public int isStartTime(Map map)throws Exception{
		 return (int) queryForExtObject("HosSendAdvice.isStartTime", map);
	 }
	public int isNumeric(Map map)throws Exception{
		return (int) queryForExtObject("HosSendAdvice.isNumeric", map);
	 }
	public void saveVDC1(Map map)throws Exception{
		update("HosSendAdvice.saveVDC1", map);
	}
	public Long getVAA07(Map map)throws Exception{
		return (Long) queryForExtObject("HosSendAdvice.getVAA07", map);
	}
	public BigDecimal getVB05(Map map)throws Exception{
		return (BigDecimal) queryForExtObject("HosSendAdvice.getVB05", map);
	}
	public BigDecimal getVB06(Map map)throws Exception{
		return (BigDecimal) queryForExtObject("HosSendAdvice.getVB06", map);
	}
	public void updatePersonBanlance(Map map)throws Exception{
		update("HosSendAdvice.updatePersonBanlance", map);
	}
	public void updateInpatient(Map map)throws Exception{
		update("HosSendAdvice.updateInpatient", map);
	}
	//病人是否有余额记录 
	public int patientBlanceCount(Map map)throws Exception{
		return (int) queryForExtObject("HosSendAdvice.patientBlanceCount", map);
	}
	//有记录 修改
	public void updateBlance(Map map)throws Exception{
		update("HosSendAdvice.updateBlance", map);
	}
	//无记录 新增
	public void insertBlance(Map map)throws Exception{
		insert("HosSendAdvice.insertBlance", map);
	}
	
	//病人是否有余额记录 
		public int blanceCount(Map map)throws Exception{
			return (int) queryForExtObject("HosSendAdvice.blanceCount", map);
		}
		//有记录 修改
		public void updatePatientBlance(Map map)throws Exception{
			update("HosSendAdvice.updatePatientBlance", map);
		}
		//无记录 新增
		public void insertPatientBlance(Map map)throws Exception{
			insert("HosSendAdvice.insertPatientBlance", map);
		}
		 
		public void nurseVCM1Update(Map map)throws Exception{
			update("HosSendAdvice.nurseVCM1Update", map);
			
		}
		public List queryPathWay(Map map)throws Exception{
			return queryForList("HosSendAdvice.queryPathWay", map);
		}
		 public List selectPatientInfo(Map map)throws Exception{
			 return queryForList("HosSendAdvice.selectPatientInfo", map);
		 }
		 public List checkMedical(Map map)throws Exception{
			 return queryForList("HosSendAdvice.checkMedical", map);
		 }
		 public List nurseAdviceSendDrug(Map map)throws Exception{
			 return queryForList("HosSendAdvice.nurseAdviceSendDrug", map);
		 }
		 public List nurseAdviceSendDrug1(Map map)throws Exception{
			 return queryForList("HosSendAdvice.nurseAdviceSendDrug1", map);
		 }
		 public List nurseAdviceSendDrug2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.nurseAdviceSendDrug2", map);
		 }
		 public List nurseAdviceSendDrug3(Map map)throws Exception{
			 return queryForList("HosSendAdvice.nurseAdviceSendDrug3", map);
		 }
		 public List nurseAdviceSendDrug4(Map map)throws Exception{
			 return queryForList("HosSendAdvice.nurseAdviceSendDrug4", map);
		 }
		 public String getSysParamValue()throws Exception{
			   return (String)this.queryToObject("HosSendAdvice.getSysParamValue", null);
		   }
		 public List getTempBAD(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempBAD", map);
		 }
		 public List tmpAdvCur(Map map)throws Exception{
			 return queryForList("HosSendAdvice.tmpAdvCur", map);
		 }
		 public Map getMinMax(Map map)throws Exception{
			 return (Map)this.queryToObject("HosSendAdvice.getMinMax", map);
		 }
		 public List getAdvicePrice(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getAdvicePrice", map);
		 }
		 public List advicePrice(Map map)throws Exception{
			 return queryForList("HosSendAdvice.advicePrice", map);
		 }
		 public Map getParamValue()throws Exception{
			 return (Map) queryForExtObject("HosSendAdvice.getParamValue",null);
		 }
		 public List queryTempLongAdvice(Map map)throws Exception{
			 return queryForList("HosSendAdvice.queryTempLongAdvice", map);
		 }
		 public List queryTempBDA(Map map)throws Exception{
			 return queryForList("HosSendAdvice.queryTempBDA", map);
		 }
		 public int checkDateDiff(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.checkDateDiff",map);
		 }
		 public int checkDisable(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.checkDisable",map);
		 }
		 public List getBDA(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getBDA", map);
		 }
		 public List tempData(Map map)throws Exception{
			 return queryForList("HosSendAdvice.tempData", map);
		 }
		 public List tempData1(Map map)throws Exception{
			 return queryForList("HosSendAdvice.tempData1", map);
		 }
		 
		 public List tempVBD(Map map)throws Exception{
			 return queryForList("HosSendAdvice.tempVBD", map);
		 }
		 public int getMaxValue(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.getMaxValue",map);
		 }
		 public List getVBD(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getVBD", map);
		 }
		 public int checkPriceContent(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.checkPriceContent",map);
		 }
		 public List queryPriceContent(Map map)throws Exception{
			 return queryForList("HosSendAdvice.queryPriceContent", map);
		 }
		 public List updateVBD(Map map)throws Exception{
			 return queryForList("HosSendAdvice.updateVBD", map);
		 }
		 public int VAFCount(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.VAFCount",map);
		 }
		 public List updatePriceOffice(Map map)throws Exception{
			 return queryForList("HosSendAdvice.updatePriceOffice", map);
		 }
		 public List queryVaj2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.queryVaj2", map);
		 }
		 public List queryVai2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.queryVai2", map);
		 }
		 
		 //判断医嘱作废或停止
		 public List getStopAdvice(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getStopAdvice", map);
		   }
		   //判断医嘱作废或发送
		
		 public List getSendAdvice(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getSendAdvice", map);
		   }
		   //药品禁售
		
		 public List getDisableSale(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getDisableSale", map);
		   }
		 public List tempVaj2(Map map)throws Exception{
			 
			 return queryForList("HosSendAdvice.tempVaj2", map);
		 }
		 public List limitMoney(Map map)throws Exception{
			 return queryForList("HosSendAdvice.limitMoney", map);
		 }
		 public int checkStore(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.checkStore",map);
		 }
		 public List getLimitStore(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getLimitStore", map);
		 }
		 public List paramLimit(Map map)throws Exception{
			 return queryForList("HosSendAdvice.paramLimit", map);
		 }
		 
		 
		 public Map getParameters()throws Exception{
			 return (Map) queryForExtObject("HosSendAdvice.getParameters",null);
		 }
		 public List getTempVAF2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVAF2",map);
		 }
		 public int checkBAD04(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.checkBAD04",map);
		   }
		 public List updateVAF(Map map)throws Exception{
			 return queryForList("HosSendAdvice.updateVAF", map);
		 }
		 public List getTempBDA(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempBDA", map);
		 }
		 
		 public String checkDisableMedical(Map map)throws Exception{
			 return (String) queryForExtObject("HosSendAdvice.checkDisableMedical", map);
		 }
		 
		 public List queryTemVBD(Map map)throws Exception{
			 return queryForList("HosSendAdvice.queryTemVBD", map);
		 }
		 
		 public List getgetkbmjzbs1(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getgetkbmjzbs1", map);
		 }
		 
		 public int getMDay(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.getMDay",map);
		 }
		 public List getgetkbmjzbs2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getgetkbmjzbs2", map);
		 }
		 public List getgetkbmjzbs(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getgetkbmjzbs", map);
		 }
		 public int getMaxDay(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.getMaxDay",map);
		 }
		 public List getTempVBD(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVBD", map);
		 }
		 public List getTempVBD1(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVBD1", map);
		 }
		 public List getTempVBD2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVBD2", map);
		 }
		 public int checkCount(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.checkCount",map);
		 }
		 public List getTempVBD3(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVBD3", map);
		 }
		 public String getPriceContent(Map map)throws Exception{
			 return (String) queryForExtObject("HosSendAdvice.getPriceContent", map);
		 }
		 public List getTempVAJ(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVAJ", map);
		 }
		 public List getTempVAI(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVAI", map);
		 }
		 public List getTempVAJ2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVAJ2", map);
		 }
		 public List getTmpVAFzt2(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTmpVAFzt2", map);
		 }
		 
		 public List getTempVAI21(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVAI21", map);
			 
		 }
		 public List getTempVAI22(Map map)throws Exception{
			 return queryForList("HosSendAdvice.getTempVAI22", map);
			 
		 }
		 public int getMXDay(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.getMXDay", map);
		 }
		 public int isVaf(Map map)throws Exception{
			 return (int) queryForExtObject("HosSendAdvice.isVaf", map);
		 }
		  public List getkbmVAT(Map map)throws Exception{
			  return queryForList("HosSendAdvice.getkbmVAT", map);
		   }
		  public List getTmpVAV(Map map)throws Exception{
			  return queryForList("HosSendAdvice.getTmpVAV", map);
		   }
		  public List getTmpDPT(Map map)throws Exception{
			  return queryForList("HosSendAdvice.getTmpDPT", map);
		  }
		  
		  public List getTmpCLDPT(Map map)throws Exception{
			  return queryForList("HosSendAdvice.getTmpCLDPT", map);
		  }
		  
		  public int isDelete(Map map)throws Exception{
			  return (int) queryForExtObject("HosSendAdvice.isDelete", map);
		   }
		  public int isExecute(Map map)throws Exception{
			  return (int) queryForExtObject("HosSendAdvice.isExecute", map);
		   }
		  public String isForbidden(Map map)throws Exception{
			  return (String) queryForExtObject("HosSendAdvice.isForbidden", map);
		   }
		  public void insertDPTLog(Map map)throws Exception{
			  insert("HosSendAdvice.insertDPTLog", map);
		  }
		  public List getBlanceParams(Map map)throws Exception{
			  return queryForList("HosSendAdvice.getBlanceParams", map);
		  }
		  public void insertFee(Map map)throws Exception{
			  insert("HosSendAdvice.insertFee", map);
		  }
		  
		  
		  public void updateVAF2(Map map)throws Exception{
			  update("HosSendAdvice.updateVAF2", map);
		  }
		  public void insertVBI2(Map map)throws Exception{
			  insert("HosSendAdvice.insertVBI2", map);
		  }
		  public void insertVBG2(Map map)throws Exception{
			  insert("HosSendAdvice.insertVBG2", map);
		  }
		  public Map isPriceContent(Map map)throws Exception{
			  return (Map) queryForExtObject("HosSendAdvice.isPriceContent", map);
		  }
		  public List checkperson(Map map)throws Exception{
			  return queryForList("HosSendAdvice.checkperson", map);
		  }
		  public int isVAE1(Map map)throws Exception{
			  return (int) queryForExtObject("HosSendAdvice.isVAE1", map);
		  }
		  public void insertVBO1(Map map)throws Exception{
			  insert("HosSendAdvice.insertVBO1", map);
		  }
		  public int isOPS(Map map)throws Exception{
			  return (int) queryForExtObject("HosSendAdvice.isOPS", map);
		  }
		  //手术单记录
		  public void insertCBM2(Map map)throws Exception{
			  insert("HosSendAdvice.insertCBM2", map);
		   }
		   //病人手术记录
		  public void insertVAT2(Map map)throws Exception{
			  insert("HosSendAdvice.insertVAT2", map);
		   }
		  //手术情况记录
		   public void insertVAV2(Map map)throws Exception{
			   insert("HosSendAdvice.insertVAV2", map);
		   }
		   //医嘱执行通知
		   public void insertVBX2(Map map)throws Exception{
			   insert("HosSendAdvice.insertVBX2", map);
		   }
		   //医嘱提醒
		   public void updateVBZ2(Map map)throws Exception{
			   update("HosSendAdvice.updateVBZ2", map);
		   }
		   
		   public List gettmp_DPT1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.gettmp_DPT1", map);
		   }
		   public void updateDPT1(Map tmpDPT1)throws Exception{
			   update("HosSendAdvice.updateDPT1", tmpDPT1);
		   }
		 //药品医嘱
		   public String  getBBY05(Map bby01)throws Exception{
			   return (String) queryForExtObject("HosSendAdvice.getBBY05", bby01);
		   }
		   
		   public String getaParamno()throws Exception{
			   return (String) queryForExtObject("HosSendAdvice.getaParamno", null);
			   
		   }
		   
		   public int getAmount(Map map)throws Exception{
			   return (int) queryForExtObject("HosSendAdvice.getAmount", map);
		   }
		   
		   public List treatmentType()throws Exception{
			   return queryForList("HosSendAdvice.treatmentType", null);
		   }
		   public List currentOffice()throws Exception{
			   return queryForList("HosSendAdvice.currentOffice", null);
		   }
		   
		  
		   public List nurseAdviceSendOther(Map map)throws Exception{
			   return queryForList("HosSendAdvice.nurseAdviceSendOther", map);
		   }
		   
		   
		   
		   public List nurseAdviceSendOtherPrice(Map map)throws Exception{
			   return queryForList("HosSendAdvice.nurseAdviceSendOtherPrice", map);
		   }
		   public Map getPara209_para262()throws Exception{
			   return (Map) queryForExtObject("HosSendAdvice.getPara209_para262", null);
		   }
		   
		   public List getBDAother(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getBDAother", map);
		   }
		   
		   public List getTmp_AdvCur(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTmp_AdvCur", map);
		   }
		   
		   public List getAdv_Price(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price", map);
		   }
		   //当前用户是否护士
		   public int checkNurse()throws Exception{
			   return (int) queryForExtObject("HosSendAdvice.checkNurse", null);
		   }
		   public Map params_Para37_Para53_Para140_gpara91()throws Exception{
			   return (Map) queryForExtObject("HosSendAdvice.params_Para37_Para53_Para140_gpara91", null);
		   }
		   
		   public List  getTempAdvice(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTempAdvice", map);
		   }
		   
		   public List getVBD2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getVBD2", map);
		   }
		   public List getVAJ2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getVAJ2", map);
		   }
		   
		   public String checkDate(Map map)throws Exception{
			   return (String) queryForExtObject("HosSendAdvice.checkDate", map);
		   }
		   public String priceContent(Map map)throws Exception{
			   return (String) queryForExtObject("HosSendAdvice.priceContent", map);
		   }
		   
		   
		   public List getVAI2(Map map)throws Exception{
			   
			   return queryForList("HosSendAdvice.getVAI2", map);
		   }
		   
		   public List tempVAJ(Map map)throws Exception{
			   return queryForList("HosSendAdvice.tempVAJ", map);
		   }
		   
		   public List getTmpVAFzt(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTmpVAFzt", map);
		   }
		   
		   public List tmpVAI(Map map)throws Exception{
			   return queryForList("HosSendAdvice.tmpVAI", map);
		   }
		   
		   public int isDestory(Map map)throws Exception{
			   return (int) queryForExtObject("HosSendAdvice.isDestory", map);
		   }
		   public String isForbid(Map map)throws Exception{
			   return (String) queryForExtObject("HosSendAdvice.isForbid", map);
		   }
		   public int checkOPS(Map map)throws Exception{
			   return (int) queryForExtObject("HosSendAdvice.checkOPS", map);
		   }
		   public List getTmpVAT(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTmpVAT", map);
		   }
		   public List getTmpVAV2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTmpVAV2", map);
		   }
		   public void insertVAI2_VAJ2_VAJT(Map map)throws Exception{
			   insert("HosSendAdvice.insertVAI2_VAJ2_VAJT", map);
			   
		   }
		   public void updateVAF2_VBI2(Map map)throws Exception{
			   update("HosSendAdvice.updateVAF2_VBI2", map);
		   }
		   public void insertVBD2(Map map)throws Exception{
			   insert("HosSendAdvice.insertVBD2", map);
		   }
		   public void addVBG2(Map map)throws Exception{
			   insert("HosSendAdvice.addVBG2", map);
		   }
		   public void insertCBM2_VAT1_VAV1(Map map)throws Exception{
			   insert("HosSendAdvice.insertCBM2_VAT1_VAV1", map);
		   }
		   public int isOperation(Map map)throws Exception{
			   return (int) queryForExtObject("HosSendAdvice.isOperation", map);
		   }
		   public int isCare(Map map)throws Exception{
			   return (int) queryForExtObject("HosSendAdvice.isCare", map);
		   }
		   public List getVBO1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getVBO1", map);
		   }
		   public void addVBO1(Map map)throws Exception{
			   insert("HosSendAdvice.addVBO1", map);
		   }
		   public void updateVBX1_VBZ1(Map map)throws Exception{
			   update("HosSendAdvice.updateVBX1_VBZ1", map);
		   }
		   public List getVAA01_VAA07_aVAF38(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getVAA01_VAA07_aVAF38", map);
		   }
		   
		   public  List getDEPT(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getDEPT", map);
		   }
		   
		   public  List getCLDEPT(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getCLDEPT", map);
		   }
		   
		   
		   public List getTmpVBO1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTmpVBO1", map);
		   }
		   
		   //手术费用 临嘱
		   public List getAdv_Price_S2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price_S2", map);
		   }
		 //手术费用  长嘱
		   public List getAdv_Price_S1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price_S1", map);
		   }
		  //检查 
		   public List getAdv_Price_E2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price_E2", map);
		   }
		   public List getAdv_Price_E1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price_E1", map);
		   }
		   //其他类
		   public List getAdv_Price_Z2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price_Z2", map);
		   }
		   public List getAdv_Price_Z1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getAdv_Price_Z1", map);
		   }
		   public Page drugAdviceList(Map map,int currPage,int pageSize) throws Exception{
			   
			   return queryForPage("HosSendAdvice.drugAdviceList", map, currPage, pageSize);
			   
		   }
		   
		   public List getBDA12(Map map)throws Exception{
			   
			   return queryForList("HosSendAdvice.getBDA12", map);
		   }
		   
		   public Page otherAdviceList(Map map,int currPage,int pageSize)throws Exception{
			   return queryForPage("HosSendAdvice.otherAdviceList", map, currPage, pageSize);
		   }
		   
		   public List getBDAOther2(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getBDAOther2", map);
		   }
		   //////////////////////////////////////////////
		   public List getBBX1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getBBX1", map);
		   }
		   public List getBCK1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getBCK1", map);
		   }
		   public List getVEA1(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getVEA1", map);
		   }
		   public List getTmpVAFzt_(Map map)throws Exception{
			   return queryForList("HosSendAdvice.getTmpVAFzt_", map);
		   }
	//---库存处理---
	public Map getRefQtyAndSellQty(Map map)throws Exception{
		return (Map) queryForExtObject("HosSendAdvice.getRefQtyAndSellQty", map);
	}
	public List select_tmp_DPT1_param1(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param1", map);
	}
	public List select_tmp_DPT1_param2(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param2", map);
	}
	public List select_tmp_DPT1_param3(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param3", map);
	}
	public List select_tmp_DPT1_param4(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param4", map);
	}
	public List select_tmp_DPT1_param5(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param5", map);
	}
	public List select_tmp_DPT1_param6(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param6", map);
	}
	public List select_tmp_DPT1_param7(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param7", map);
	}
	public List select_tmp_DPT1_param8(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param8", map);
	}
	public Map getMaxAndMin(Map map)throws Exception{
		return (Map) queryForExtObject("HosSendAdvice.getMaxAndMin", map);
	}
	public Map getRefQtyAndSellQty1(Map map)throws Exception{
		return (Map) queryForExtObject("HosSendAdvice.getRefQtyAndSellQty1", map);
	}
	//---物资库存处理---
	public Map getRefQtyAndSellQtywz(Map map)throws Exception{
		return (Map) queryForExtObject("HosSendAdvice.getRefQtyAndSellQtywz", map);
	}
	public List select_tmp_DPT1_param1wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param1wz", map);
	}
	public List select_tmp_DPT1_param2wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param2wz", map);
	}
	public List select_tmp_DPT1_param3wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param3wz", map);
	}
	public List select_tmp_DPT1_param4wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param4wz", map);
	}
	public List select_tmp_DPT1_param5wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param5wz", map);
	}
	public List select_tmp_DPT1_param6wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param6wz", map);
	}
	public List select_tmp_DPT1_param7wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param7wz", map);
	}
	public List select_tmp_DPT1_param8wz(Map map)throws Exception{
		return queryForList("HosSendAdvice.update_tmp_DPT1_param8wz", map);
	}
	public Map getMaxAndMinwz(Map map)throws Exception{
		return (Map) queryForExtObject("HosSendAdvice.getMaxAndMinwz", map);
	}
	public Map getRefQtyAndSellQty1wz(Map map)throws Exception{
		return (Map) queryForExtObject("HosSendAdvice.getRefQtyAndSellQty1wz", map);
	}
	public void updateStock(Map map)throws Exception{
		update("HosSendAdvice.updateStock", map);
	}
	//--库存处理结束---
	public List getvae1(List ls) throws Exception {
		return (List) queryForExtObject("HosSendAdvice.getvae1", ls);
	}
	//清理临时表
	public void cleantable(Map map)throws Exception{
		update("HosSendAdvice.cleantable", map);
	}
	public List<Map<String, Object>> getLimitStore1(Map map,int type) throws Exception{
		// TODO Auto-generated method stub
		if(type==0){
			return queryForList("HosSendAdvice.getLimitStore2", map);
		}else{
			return queryForList("HosSendAdvice.getLimitStore1", map);
		}
		
	}
} 
